package com.example.logistics_oa.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.comment_oa.pojos.JobMakeoffer;
import com.example.comment_oa.pojos_vo.JibenSalaryChaXunVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author 安徽彭于晏
* @description 针对表【job_makeoffer】的数据库操作Mapper
* @createDate 2022-10-17 08:45:03
* @Entity com.example.logistics_oa.domain.JobMakeoffer
*/
@Mapper
public interface JobMakeofferMapper extends BaseMapper<JobMakeoffer> {
    public List<JobMakeoffer> selectAll(@Param("JibenSalaryChaXunVo") JibenSalaryChaXunVo jibenSalaryChaXunVo);

    //修改岗位津贴
    public int updateGangWeiJinTie(@Param("jmoJobsalary") Double jmoJobsalary,@Param("jmoId") int jmoId );

    //修改最低最高工资  三连
    public int updateMinSalary(@Param("jmoMinsalary") Double jmoMinsalary,@Param("jmoId") int jmoId );
    public int updateMaxSalary(@Param("jmoMaxsalary") Double jmoMaxsalary,@Param("jmoId") int jmoId );
    public int updateMaxAndMin(@Param("jmoMaxsalary") Double jmoJobsalary,@Param("jmoMinsalary") Double jmoMinsalary,@Param("jmoId") int jmoId );

    // 查询出这个人对应的 岗位津贴
    public List<JobMakeoffer> selectGangWeiJinTie(@Param("jmoDepartmentid") int jmoDepartmentid,@Param("jmoJobid") int jmo_jobid);

    //根据职务ID 查询最高和最低
    public List<JobMakeoffer> selectMaxAndMinByZhiwuId(@Param("jmoJobid") int jmoJobid);

}




